Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	1017209
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	179.7 MiB
Average record size in memory	185.2 B

Variable types

Numeric	9
DateTime	1
Categorical	9
Unsupported	1

Alerts

`day_of_week` is highly overall correlated with `open`	High correlation
`sales` is highly overall correlated with `customers` and 1 other fields	High correlation
`customers` is highly overall correlated with `sales`	High correlation
`promo2_since_year` is highly overall correlated with `promo2`	High correlation
`open` is highly overall correlated with `day_of_week` and 1 other fields	High correlation
`store_type` is highly overall correlated with `assortment`	High correlation
`assortment` is highly overall correlated with `store_type`	High correlation
`promo2` is highly overall correlated with `promo2_since_year`	High correlation
`state_holiday` is highly imbalanced (88.2%)	Imbalance
`promo_interval` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`sales` has 172871 (17.0%) zeros	Zeros
`customers` has 172869 (17.0%) zeros	Zeros

Reproduction

Analysis started	2023-09-22 18:41:09.556427
Analysis finished	2023-09-22 18:42:08.863303
Duration	59.31 seconds
Software version	pandas-profiling v0.0.dev0
Download configuration	config.json

store
Real number (ℝ)

Distinct	1115
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	558.42973

Minimum	1
Maximum	1115
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.5 MiB

Quantile statistics

Minimum	1
5-th percentile	56
Q1	280
median	558
Q3	838
95-th percentile	1060
Maximum	1115
Range	1114
Interquartile range (IQR)	558

Descriptive statistics

Standard deviation	321.90865
Coefficient of variation (CV)	0.57645329
Kurtosis	-1.2005237
Mean	558.42973
Median Absolute Deviation (MAD)	279
Skewness	-0.00095487998
Sum	5.6803974 × 10⁸
Variance	103625.18
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	942	0.1%
726	942	0.1%
708	942	0.1%
709	942	0.1%
713	942	0.1%
714	942	0.1%
715	942	0.1%
717	942	0.1%
718	942	0.1%
720	942	0.1%
Other values (1105)	1007789	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	942	0.1%
2	942	0.1%
3	942	0.1%
4	942	0.1%
5	942	0.1%
6	942	0.1%
7	942	0.1%
8	942	0.1%
9	942	0.1%
10	942	0.1%

Value	Count	Frequency (%)
1115	942	0.1%
1114	942	0.1%
1113	942	0.1%
1112	942	0.1%
1111	942	0.1%
1110	942	0.1%
1109	758	0.1%
1108	942	0.1%
1107	758	0.1%
1106	942	0.1%

day_of_week
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.9983406

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.997391
Coefficient of variation (CV)	0.49955499
Kurtosis	-1.2468733
Mean	3.9983406
Median Absolute Deviation (MAD)	2
Skewness	0.0015928228
Sum	4067148
Variance	3.9895707
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
5	145845	14.3%
4	145845	14.3%
3	145665	14.3%
2	145664	14.3%
1	144730	14.2%
7	144730	14.2%
6	144730	14.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	144730	14.2%
2	145664	14.3%
3	145665	14.3%
4	145845	14.3%
5	145845	14.3%
6	144730	14.2%
7	144730	14.2%

Value	Count	Frequency (%)
7	144730	14.2%
6	144730	14.2%
5	145845	14.3%
4	145845	14.3%
3	145665	14.3%
2	145664	14.3%
1	144730	14.2%

date
Date

Distinct	942
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.5 MiB

Minimum	2013-01-01 00:00:00
Maximum	2015-07-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

sales
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	21734
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5773.819

Minimum	0
Maximum	41551
Zeros	172871
Zeros (%)	17.0%
Negative	0
Negative (%)	0.0%
Memory size	15.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3727
median	5744
Q3	7856
95-th percentile	12137
Maximum	41551
Range	41551
Interquartile range (IQR)	4129

Descriptive statistics

Standard deviation	3849.9262
Coefficient of variation (CV)	0.66679025
Kurtosis	1.7783747
Mean	5773.819
Median Absolute Deviation (MAD)	2067
Skewness	0.64145962
Sum	5.8731806 × 10⁹
Variance	14821932
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	172871	17.0%
5674	215	< 0.1%
5558	197	< 0.1%
5483	196	< 0.1%
6214	195	< 0.1%
6049	195	< 0.1%
5723	194	< 0.1%
5449	192	< 0.1%
5140	191	< 0.1%
5489	191	< 0.1%
Other values (21724)	842572	82.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	172871	17.0%
46	1	< 0.1%
124	1	< 0.1%
133	1	< 0.1%
286	1	< 0.1%
297	1	< 0.1%
316	1	< 0.1%
416	1	< 0.1%
506	1	< 0.1%
520	1	< 0.1%

Value	Count	Frequency (%)
41551	1	< 0.1%
38722	1	< 0.1%
38484	1	< 0.1%
38367	1	< 0.1%
38037	1	< 0.1%
38025	1	< 0.1%
37646	1	< 0.1%
37403	1	< 0.1%
37376	1	< 0.1%
37122	1	< 0.1%

customers
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	4086
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	633.14595

Minimum	0
Maximum	7388
Zeros	172869
Zeros (%)	17.0%
Negative	0
Negative (%)	0.0%
Memory size	15.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	405
median	609
Q3	837
95-th percentile	1362
Maximum	7388
Range	7388
Interquartile range (IQR)	432

Descriptive statistics

Standard deviation	464.41173
Coefficient of variation (CV)	0.73349871
Kurtosis	7.0917727
Mean	633.14595
Median Absolute Deviation (MAD)	216
Skewness	1.5986503
Sum	6.4404176 × 10⁸
Variance	215678.26
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	172869	17.0%
560	2414	0.2%
576	2363	0.2%
603	2337	0.2%
571	2330	0.2%
555	2328	0.2%
566	2327	0.2%
517	2326	0.2%
539	2309	0.2%
651	2299	0.2%
Other values (4076)	823307	80.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	172869	17.0%
3	1	< 0.1%
5	1	< 0.1%
8	1	< 0.1%
13	1	< 0.1%
18	1	< 0.1%
36	1	< 0.1%
40	1	< 0.1%
44	1	< 0.1%
50	1	< 0.1%

Value	Count	Frequency (%)
7388	1	< 0.1%
5494	1	< 0.1%
5458	1	< 0.1%
5387	1	< 0.1%
5297	1	< 0.1%
5192	1	< 0.1%
5152	1	< 0.1%
5145	1	< 0.1%
5132	1	< 0.1%
5112	1	< 0.1%

open
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.5 MiB

1	844392
0	172817

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1017209
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	844392	83.0%
0	172817	17.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	844392	83.0%
0	172817	17.0%

Most occurring characters

Value	Count	Frequency (%)
1	844392	83.0%
0	172817	17.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1017209	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	844392	83.0%
0	172817	17.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1017209	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	844392	83.0%
0	172817	17.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1017209	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	844392	83.0%
0	172817	17.0%

promo
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.5 MiB

0	629129
1	388080

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1017209
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	629129	61.8%
1	388080	38.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	629129	61.8%
1	388080	38.2%

Most occurring characters

Value	Count	Frequency (%)
0	629129	61.8%
1	388080	38.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1017209	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	629129	61.8%
1	388080	38.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	1017209	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	629129	61.8%
1	388080	38.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1017209	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	629129	61.8%
1	388080	38.2%

state_holiday
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.5 MiB

0	986159
a	20260
b	6690
c	4100

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1017209
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	986159	96.9%
a	20260	2.0%
b	6690	0.7%
c	4100	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	986159	96.9%
a	20260	2.0%
b	6690	0.7%
c	4100	0.4%

Most occurring characters

Value	Count	Frequency (%)
0	986159	96.9%
a	20260	2.0%
b	6690	0.7%
c	4100	0.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	986159	96.9%
Lowercase Letter	31050	3.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	20260	65.2%
b	6690	21.5%
c	4100	13.2%

Decimal Number

Value	Count	Frequency (%)
0	986159	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	986159	96.9%
Latin	31050	3.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	20260	65.2%
b	6690	21.5%
c	4100	13.2%

Common

Value	Count	Frequency (%)
0	986159	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1017209	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	986159	96.9%
a	20260	2.0%
b	6690	0.7%
c	4100	0.4%

school_holiday
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.5 MiB

0	835488
1	181721

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1017209
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	835488	82.1%
1	181721	17.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	835488	82.1%
1	181721	17.9%

Most occurring characters

Value	Count	Frequency (%)
0	835488	82.1%
1	181721	17.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1017209	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	835488	82.1%
1	181721	17.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	1017209	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	835488	82.1%
1	181721	17.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1017209	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	835488	82.1%
1	181721	17.9%

store_type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.5 MiB

a	551627
d	312912
c	136840
b	15830

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1017209
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	c
2nd row	a
3rd row	a
4th row	c
5th row	a

Common Values

Value	Count	Frequency (%)
a	551627	54.2%
d	312912	30.8%
c	136840	13.5%
b	15830	1.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	551627	54.2%
d	312912	30.8%
c	136840	13.5%
b	15830	1.6%

Most occurring characters

Value	Count	Frequency (%)
a	551627	54.2%
d	312912	30.8%
c	136840	13.5%
b	15830	1.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1017209	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	551627	54.2%
d	312912	30.8%
c	136840	13.5%
b	15830	1.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1017209	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	551627	54.2%
d	312912	30.8%
c	136840	13.5%
b	15830	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1017209	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	551627	54.2%
d	312912	30.8%
c	136840	13.5%
b	15830	1.6%

assortment
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.5 MiB

a	537445
c	471470
b	8294

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1017209
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	a
2nd row	a
3rd row	a
4th row	c
5th row	a

Common Values

Value	Count	Frequency (%)
a	537445	52.8%
c	471470	46.3%
b	8294	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	537445	52.8%
c	471470	46.3%
b	8294	0.8%

Most occurring characters

Value	Count	Frequency (%)
a	537445	52.8%
c	471470	46.3%
b	8294	0.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1017209	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	537445	52.8%
c	471470	46.3%
b	8294	0.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1017209	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	537445	52.8%
c	471470	46.3%
b	8294	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1017209	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	537445	52.8%
c	471470	46.3%
b	8294	0.8%

competition_distance
Real number (ℝ)

Distinct	655
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5935.4427

Minimum	20
Maximum	200000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.5 MiB

Quantile statistics

Minimum	20
5-th percentile	130
Q1	710
median	2330
Q3	6910
95-th percentile	20620
Maximum	200000
Range	199980
Interquartile range (IQR)	6200

Descriptive statistics

Standard deviation	12547.653
Coefficient of variation (CV)	2.1140214
Kurtosis	147.78971
Mean	5935.4427
Median Absolute Deviation (MAD)	1980
Skewness	10.242344
Sum	6.0375857 × 10⁹
Variance	1.574436 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
250	11120	1.1%
50	7536	0.7%
350	7536	0.7%
1200	7374	0.7%
190	7352	0.7%
180	6594	0.6%
90	6594	0.6%
330	6410	0.6%
150	6226	0.6%
2640	5652	0.6%
Other values (645)	944815	92.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20	942	0.1%
30	3767	0.4%
40	4710	0.5%
50	7536	0.7%
60	2826	0.3%
70	4526	0.4%
80	2826	0.3%
90	6594	0.6%
100	4710	0.5%
110	5468	0.5%

Value	Count	Frequency (%)
200000	2642	0.3%
75860	942	0.1%
58260	942	0.1%
48330	942	0.1%
46590	942	0.1%
45740	942	0.1%
44320	942	0.1%
40860	942	0.1%
40540	942	0.1%
38710	942	0.1%

competition_open_since_month
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.7868491

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.6 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.3110867
Coefficient of variation (CV)	0.48786804
Kurtosis	-1.2326075
Mean	6.7868491
Median Absolute Deviation (MAD)	3
Skewness	-0.04207563
Sum	6903644
Variance	10.963295
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
9	133844	13.2%
4	118936	11.7%
11	104045	10.2%
3	96470	9.5%
7	90651	8.9%
12	78139	7.7%
6	77304	7.6%
10	75865	7.5%
5	72530	7.1%
2	67622	6.6%
Other values (2)	101803	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	45374	4.5%
2	67622	6.6%
3	96470	9.5%
4	118936	11.7%
5	72530	7.1%
6	77304	7.6%
7	90651	8.9%
8	56429	5.5%
9	133844	13.2%
10	75865	7.5%

Value	Count	Frequency (%)
12	78139	7.7%
11	104045	10.2%
10	75865	7.5%
9	133844	13.2%
8	56429	5.5%
7	90651	8.9%
6	77304	7.6%
5	72530	7.1%
4	118936	11.7%
3	96470	9.5%

competition_open_since_year
Real number (ℝ)

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2010.3248

Minimum	1900
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.6 MiB

Quantile statistics

Minimum	1900
5-th percentile	2002
Q1	2008
median	2012
Q3	2014
95-th percentile	2015
Maximum	2015
Range	115
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	5.5155933
Coefficient of variation (CV)	0.0027436329
Kurtosis	124.0713
Mean	2010.3248
Median Absolute Deviation (MAD)	2
Skewness	-7.2356575
Sum	2.0449205 × 10⁹
Variance	30.421769
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
2013	204636	20.1%
2014	182822	18.0%
2015	110108	10.8%
2012	74299	7.3%
2005	56564	5.6%
2010	51258	5.0%
2009	49396	4.9%
2011	49396	4.9%
2008	48476	4.8%
2007	43744	4.3%
Other values (13)	146510	14.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1900	758	0.1%
1961	942	0.1%
1990	4710	0.5%
1994	1884	0.2%
1995	1700	0.2%
1998	942	0.1%
1999	7352	0.7%
2000	9236	0.9%
2001	14704	1.4%
2002	24882	2.4%

Value	Count	Frequency (%)
2015	110108	10.8%
2014	182822	18.0%
2013	204636	20.1%
2012	74299	7.3%
2011	49396	4.9%
2010	51258	5.0%
2009	49396	4.9%
2008	48476	4.8%
2007	43744	4.3%
2006	42802	4.2%

promo2
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.5 MiB

1	509178
0	508031

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1017209
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
1	509178	50.1%
0	508031	49.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	509178	50.1%
0	508031	49.9%

Most occurring characters

Value	Count	Frequency (%)
1	509178	50.1%
0	508031	49.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1017209	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	509178	50.1%
0	508031	49.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	1017209	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	509178	50.1%
0	508031	49.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1017209	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	509178	50.1%
0	508031	49.9%

promo2_since_week
Real number (ℝ)

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.619033

Minimum	1
Maximum	52
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.6 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	12
median	22
Q3	37
95-th percentile	47
Maximum	52
Range	51
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	14.310064
Coefficient of variation (CV)	0.60587003
Kurtosis	-1.1840463
Mean	23.619033
Median Absolute Deviation (MAD)	12
Skewness	0.17872254
Sum	24025493
Variance	204.77794
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	84414	8.3%
40	70046	6.9%
10	50252	4.9%
31	50144	4.9%
5	47242	4.6%
1	43225	4.2%
13	41244	4.1%
37	40234	4.0%
22	40118	3.9%
18	38742	3.8%
Other values (42)	511548	50.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	43225	4.2%
2	11424	1.1%
3	11424	1.1%
4	11424	1.1%
5	47242	4.6%
6	12366	1.2%
7	11424	1.1%
8	11424	1.1%
9	23876	2.3%
10	50252	4.9%

Value	Count	Frequency (%)
52	7448	0.7%
51	7448	0.7%
50	8390	0.8%
49	8206	0.8%
48	15742	1.5%
47	7448	0.7%
46	7448	0.7%
45	36716	3.6%
44	10090	1.0%
43	7448	0.7%

promo2_since_year
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2012.7933

Minimum	2009
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.6 MiB

Quantile statistics

Minimum	2009
5-th percentile	2009
Q1	2012
median	2013
Q3	2014
95-th percentile	2015
Maximum	2015
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.6626582
Coefficient of variation (CV)	0.00082604518
Kurtosis	-0.21007513
Mean	2012.7933
Median Absolute Deviation (MAD)	1
Skewness	-0.78443626
Sum	2.0474315 × 10⁹
Variance	2.7644323
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2013	309023	30.4%
2014	274066	26.9%
2015	124380	12.2%
2011	115056	11.3%
2012	73174	7.2%
2009	65270	6.4%
2010	56240	5.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2009	65270	6.4%
2010	56240	5.5%
2011	115056	11.3%
2012	73174	7.2%
2013	309023	30.4%
2014	274066	26.9%
2015	124380	12.2%

Value	Count	Frequency (%)
2015	124380	12.2%
2014	274066	26.9%
2013	309023	30.4%
2012	73174	7.2%
2011	115056	11.3%
2010	56240	5.5%
2009	65270	6.4%

promo_interval
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	15.5 MiB

month_map
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.5 MiB

May	103695
Mar	103695
Jan	103694
Jun	100350
Apr	100350
Other values (7)	505425

Length

Max length	4
Median length	3
Mean length	3.0604596
Min length	3

Characters and Unicode

Total characters	3113127
Distinct characters	21
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jul
2nd row	Jul
3rd row	Jul
4th row	Jul
5th row	Jul

Common Values

Value	Count	Frequency (%)
May	103695	10.2%
Mar	103695	10.2%
Jan	103694	10.2%
Jun	100350	9.9%
Apr	100350	9.9%
Jul	98115	9.6%
Fev	93660	9.2%
Dec	63550	6.2%
Oct	63550	6.2%
Aug	63550	6.2%
Other values (2)	123000	12.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
may	103695	10.2%
mar	103695	10.2%
jan	103694	10.2%
jun	100350	9.9%
apr	100350	9.9%
jul	98115	9.6%
fev	93660	9.2%
dec	63550	6.2%
oct	63550	6.2%
aug	63550	6.2%
Other values (2)	123000	12.1%

Most occurring characters

Value	Count	Frequency (%)
a	311084	10.0%
J	302159	9.7%
u	262015	8.4%
e	218710	7.0%
M	207390	6.7%
r	204045	6.6%
n	204044	6.6%
A	163900	5.3%
p	161850	5.2%
v	155160	5.0%
Other values (11)	922770	29.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2095918	67.3%
Uppercase Letter	1017209	32.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	311084	14.8%
u	262015	12.5%
e	218710	10.4%
r	204045	9.7%
n	204044	9.7%
p	161850	7.7%
v	155160	7.4%
c	127100	6.1%
t	125050	6.0%
y	103695	4.9%
Other values (3)	223165	10.6%

Uppercase Letter

Value	Count	Frequency (%)
J	302159	29.7%
M	207390	20.4%
A	163900	16.1%
F	93660	9.2%
O	63550	6.2%
D	63550	6.2%
N	61500	6.0%
S	61500	6.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3113127	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	311084	10.0%
J	302159	9.7%
u	262015	8.4%
e	218710	7.0%
M	207390	6.7%
r	204045	6.6%
n	204044	6.6%
A	163900	5.3%
p	161850	5.2%
v	155160	5.0%
Other values (11)	922770	29.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3113127	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	311084	10.0%
J	302159	9.7%
u	262015	8.4%
e	218710	7.0%
M	207390	6.7%
r	204045	6.6%
n	204044	6.6%
A	163900	5.3%
p	161850	5.2%
v	155160	5.0%
Other values (11)	922770	29.6%

is_promo
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.5 MiB

0	853337
1	163872

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1017209
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	853337	83.9%
1	163872	16.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	853337	83.9%
1	163872	16.1%

Most occurring characters

Value	Count	Frequency (%)
0	853337	83.9%
1	163872	16.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1017209	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	853337	83.9%
1	163872	16.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	1017209	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	853337	83.9%
1	163872	16.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1017209	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	853337	83.9%
1	163872	16.1%

Auto

Heatmap
Table

	store	day_of_week	sales	customers	competition_distance	competition_open_since_month	competition_open_since_year	promo2_since_week	promo2_since_year	open	promo	state_holiday	school_holiday	store_type	assortment	promo2	month_map	is_promo
store	1.000	-0.000	0.001	0.022	-0.045	-0.033	0.002	0.004	0.008	0.006	0.000	0.000	0.000	0.095	0.111	0.072	0.000	0.036
day_of_week	-0.000	1.000	-0.451	-0.431	-0.000	-0.002	0.000	-0.002	0.001	0.876	0.495	0.120	0.264	0.000	0.000	0.000	0.031	0.011
sales	0.001	-0.451	1.000	0.903	-0.026	-0.002	0.029	0.056	0.063	0.705	0.453	0.155	0.083	0.108	0.081	0.104	0.044	0.051
customers	0.022	-0.431	0.903	1.000	-0.178	0.002	0.015	0.032	0.122	0.327	0.279	0.071	0.048	0.318	0.271	0.182	0.024	0.082
competition_distance	-0.045	-0.000	-0.026	-0.178	1.000	-0.024	0.007	-0.014	0.029	0.013	0.000	0.000	0.002	0.045	0.063	0.159	0.000	0.070
competition_open_since_month	-0.033	-0.002	-0.002	0.002	-0.024	1.000	-0.234	0.108	0.017	0.025	0.013	0.061	0.132	0.068	0.059	0.130	0.326	0.085
competition_open_since_year	0.002	0.000	0.029	0.015	0.007	-0.234	1.000	0.017	0.031	0.000	0.000	0.001	0.002	0.054	0.078	0.054	0.002	0.029
promo2_since_week	0.004	-0.002	0.056	0.032	-0.014	0.108	0.017	1.000	-0.121	0.033	0.052	0.101	0.182	0.073	0.091	0.283	0.432	0.161
promo2_since_year	0.008	0.001	0.063	0.122	0.029	0.017	0.031	-0.121	1.000	0.007	0.015	0.016	0.027	0.085	0.110	0.682	0.099	0.306
open	0.006	0.876	0.705	0.327	0.013	0.025	0.000	0.033	0.007	1.000	0.295	0.378	0.086	0.051	0.039	0.008	0.074	0.000
promo	0.000	0.495	0.453	0.279	0.000	0.013	0.000	0.052	0.015	0.295	1.000	0.054	0.067	0.000	0.000	0.000	0.052	0.005
state_holiday	0.000	0.120	0.155	0.071	0.000	0.061	0.001	0.101	0.016	0.378	0.054	1.000	0.213	0.002	0.002	0.011	0.220	0.027
school_holiday	0.000	0.264	0.083	0.048	0.002	0.132	0.002	0.182	0.027	0.086	0.067	0.213	1.000	0.002	0.002	0.007	0.385	0.027
store_type	0.095	0.000	0.108	0.318	0.045	0.068	0.054	0.073	0.085	0.051	0.000	0.002	0.002	1.000	0.537	0.106	0.007	0.045
assortment	0.111	0.000	0.081	0.271	0.063	0.059	0.078	0.091	0.110	0.039	0.000	0.002	0.002	0.537	1.000	0.015	0.005	0.008
promo2	0.072	0.000	0.104	0.182	0.159	0.130	0.054	0.283	0.682	0.008	0.000	0.011	0.007	0.106	0.015	1.000	0.028	0.438
month_map	0.000	0.031	0.044	0.024	0.000	0.326	0.002	0.432	0.099	0.074	0.052	0.220	0.385	0.007	0.005	0.028	1.000	0.274
is_promo	0.036	0.011	0.051	0.082	0.070	0.085	0.029	0.161	0.306	0.000	0.005	0.027	0.027	0.045	0.008	0.438	0.274	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	store	day_of_week	date	sales	customers	open	promo	school_holiday	store_type	assortment	competition_distance	competition_open_since_month	competition_open_since_year	promo2	promo2_since_week	promo2_since_year	promo_interval	month_map	is_promo
0	1	5	2015-07-31	5263	555	1	1	1	c	a	1270.000	9	2008	0	31	2015	0	Jul	0
1	2	5	2015-07-31	6064	625	1	1	1	a	a	570.000	11	2007	1	13	2010	Jan,Apr,Jul,Oct	Jul	1
2	3	5	2015-07-31	8314	821	1	1	1	a	a	14130.000	12	2006	1	14	2011	Jan,Apr,Jul,Oct	Jul	1
3	4	5	2015-07-31	13995	1498	1	1	1	c	c	620.000	9	2009	0	31	2015	0	Jul	0
4	5	5	2015-07-31	4822	559	1	1	1	a	a	29910.000	4	2015	0	31	2015	0	Jul	0
5	6	5	2015-07-31	5651	589	1	1	1	a	a	310.000	12	2013	0	31	2015	0	Jul	0
6	7	5	2015-07-31	15344	1414	1	1	1	a	c	24000.000	4	2013	0	31	2015	0	Jul	0
7	8	5	2015-07-31	8492	833	1	1	1	a	a	7520.000	10	2014	0	31	2015	0	Jul	0
8	9	5	2015-07-31	8565	687	1	1	1	a	c	2030.000	8	2000	0	31	2015	0	Jul	0
9	10	5	2015-07-31	7185	681	1	1	1	a	a	3160.000	9	2009	0	31	2015	0	Jul	0

	store	day_of_week	date	state_holiday	school_holiday	store_type	assortment	competition_distance	competition_open_since_month	competition_open_since_year	promo2	promo2_since_week	promo2_since_year	promo_interval	month_map	is_promo
1017199	1106	2	2013-01-01	a	1	a	c	5330.000	9	2011	1	31	2013	Jan,Apr,Jul,Oct	Jan	1
1017200	1107	2	2013-01-01	a	1	a	a	1400.000	6	2012	1	13	2010	Jan,Apr,Jul,Oct	Jan	1
1017201	1108	2	2013-01-01	a	1	a	a	540.000	4	2004	0	1	2013	0	Jan	0
1017202	1109	2	2013-01-01	a	1	c	a	3490.000	4	2011	1	22	2012	Jan,Apr,Jul,Oct	Jan	1
1017203	1110	2	2013-01-01	a	1	c	c	900.000	9	2010	0	1	2013	0	Jan	0
1017204	1111	2	2013-01-01	a	1	a	a	1900.000	6	2014	1	31	2013	Jan,Apr,Jul,Oct	Jan	1
1017205	1112	2	2013-01-01	a	1	c	c	1880.000	4	2006	0	1	2013	0	Jan	0
1017206	1113	2	2013-01-01	a	1	a	c	9260.000	1	2013	0	1	2013	0	Jan	0
1017207	1114	2	2013-01-01	a	1	a	c	870.000	1	2013	0	1	2013	0	Jan	0
1017208	1115	2	2013-01-01	a	1	d	c	5350.000	1	2013	1	22	2012	Mar,Jun,Sept,Dec	Jan	0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks